Tables

Relational databases use tables to store data. All operations on data are done on the tables themselves or produce another tables as the result. A table is a set of rows and columns, and their intersections are fields. From a general perspective, columns within a table describe the name and type of data that will be found by row for that column's fields. Rows within a table represent records composed of fields that are described from left to right by their corresponding column's name and type. Each field in a row is implicitly correlated with each other field in that row.

Just simply click to open an object pane for Table. By using the object pane toolbar below, you can create new, edit, open and delete the selected table.

Create Table

To create a new table

To create a new table with the same properties as one of the existing tables has (using popup menu)

Apply to: current database {same connection}
  • Select the table(s) for copying in the navigation pane/object pane.
  • Control-click and select the Duplicate Table -> Structure + Data/Structure Only from the popup menu.
  • The newly created table(s) will be named as "tablename_copy".

To create a new table with the same properties as one of the existing tables has (using drag and drop method)

Apply to: current database {same connection}
  • Select the table(s) for copying in the navigation pane/object pane.
  • Click and drag the chosen table(s) to the target location.
  • Select one of the following options:
    • Copy here (Structure only)
    • Copy here (Structure and Data)
    • Cancel
  • The newly created table(s) will be named as "tabletname_copy"
Apply to: different database {same connection}
  different database {different connection (same or cross server type)} (Data Transfer tool will be activated)
  • Select the table(s) for copying in the object pane.
  • Drag and drop the chosen table(s) to the target database.
  • Select one of the following options:

    • Copy here (Structure only)
    • Copy here (Structure and Data)
    • Cancel

To create a new table with modification as one of the existing tables

Edit Table

To edit the existing table (manage its fields, indexes, foreign keys and triggers etc)

To change the name of the table

Open Table (manage table data)

To open a table

To open a table with graphical fields

Empty Table

To empty a table

Delete Table

To delete a table

Table Shortcut

To create a table shortcut

Achieve Table Information

To achieve a table information